package com.jy.wms.dao;

import com.jy.wms.common.base.InventoryStatistics;
import com.jy.wms.common.base.LogisticsExpress;
import com.jy.wms.common.base.BaseDao;
import com.jy.wms.common.base.ShipmentOrderFx;
import com.jy.wms.pojo.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface InventoryStatisticsMapper extends BaseDao<InventoryStatistics> {
    /**
     * 库存统计报表
     * @return
     */
    public List<InventoryStatistics> stockCount(@Param("InventoryStatistics")InventoryStatistics entity);
    /**
     * 发运订单分析
     * @return
     */
    public List<ShipmentOrderFx> shipmentOrderFxa(@Param("ShipmentOrderFx") ShipmentOrderFx fx);
    /**
     *计算单个货品的总总量_Jane
     */
    public List<ShipmentOrderFx> dghpzl(@Param("ShipmentOrderFx")ShipmentOrderFx fx,@Param("hpid")String hpid);

    /**
     *计算一个单据的总重量_Jane
     * @param id
     * @return
     */
    public ShipmentOrderFx sozzl(@Param("id") String id);
    /**
     *查询当前货主下的所有货品种类_Jane
     */
    public List<WmsGoodsType> seachHpzl(@Param("ckid") String ckid,@Param("hzid") String hzid);
    /**
     *根据种类Id查询货品_Jane
     */
    public List<WmsGoods> seachHpByZlid(@Param("list")List<String> list);
    /**
     *查询订单渠道_Jane
     */
    public WmsOrderChannel seachDdqd(@Param("ckid") String ckid,@Param("hzid") String hzid,@Param("id") String id);
    /**
     *品项数分析_Jane
     */
    public List<Map<String,Object>> seachPxsfx(@Param("ShipmentOrderFx") ShipmentOrderFx entity);
    /**
     *物流快递表_Jane
     */
    public List<LogisticsExpress> seachWlkd(@Param("ckid") String ckid, @Param("sshzid") String sshzid,@Param("LogisticsExpress") LogisticsExpress entity);
    /**
     * 理论重量
     */
    public  String llzl(@Param("ysdh") String ysdh);
    /**
     * 产品汇总
     */
    public  String cphz(@Param("ysdh") String ysdh);
    /**
     * 运输箱数
     */
    public  String ysxs(@Param("ysdh") String ysdh);
    /**
     * 总金额
     */
    public String zje(@Param("hpid") String hpid,@Param("hppc") String hppc);
    /**
     * 捡货区数量
     */
    public String jhqsl(@Param("hpid") String hpid,@Param("hppc") String hppc);
    /**
     * 存储区数量
     */
    public String ccqsl(@Param("hpid") String hpid,@Param("hppc") String hppc);
    /**
     * 总数量
     */
    public String zsl(@Param("hpid") String hpid,@Param("hppc") String hppc);
}
